COVID-19 in Italy. Visuals

(alternatively, see results and code together here)

 

Data source: this GitHubi page

Authors and sources mentioned: Editore/Autore del dataset: Dipartimento della Protezione Civile. Categoria ISO 19115: Salute. Dati forniti dal Ministero della Salute.

Regional data files (Dati per Regione):
  • Struttura file giornaliero: dpc-covid19-ita-regioni-yyyymmdd.csv (dpc-covid19-ita-regioni-20200224.csv)
  • File complessivo: dpc-covid19-ita-regioni.csv
  • File ultimi dati (latest): dpc-covid19-ita-regioni-latest.csv

 

Out[4]:

Currently data as of date: 2020-11-05T17:00:00

 

What's in the original dataframe?

Out[5]:

All column names: ['data', 'stato', 'codice_regione', 'denominazione_regione', 'lat', 'long', 'ricoverati_con_sintomi', 'terapia_intensiva', 'totale_ospedalizzati', 'isolamento_domiciliare', 'totale_positivi', 'variazione_totale_positivi', 'nuovi_positivi', 'dimessi_guariti', 'deceduti', 'casi_da_sospetto_diagnostico', 'casi_da_screening', 'totale_casi', 'tamponi', 'casi_testati', 'note']

Out[6]:
data stato codice_regione denominazione_regione lat long ricoverati_con_sintomi terapia_intensiva totale_ospedalizzati isolamento_domiciliare ... variazione_totale_positivi nuovi_positivi dimessi_guariti deceduti casi_da_sospetto_diagnostico casi_da_screening totale_casi tamponi casi_testati note
5371 2020-11-05T17:00:00 ITA 19 Sicilia 38.115697 13.362357 1147 157 1304 17222 ... 908 1322 8282 594 17045.0 10357.0 27402 728244 509301.0 NaN
5372 2020-11-05T17:00:00 ITA 9 Toscana 43.769231 11.255889 1387 202 1589 35893 ... 2018 2273 16136 1470 44373.0 10715.0 55088 1164607 771596.0 effettuati 17941 tamponi rapidi antigenici di ...
5373 2020-11-05T17:00:00 ITA 10 Umbria 43.106758 12.388247 319 50 369 8020 ... 553 768 4270 165 3674.0 9150.0 12824 316038 182633.0 NaN
5374 2020-11-05T17:00:00 ITA 2 Valle d'Aosta 45.737503 7.320149 160 12 172 1980 ... 28 114 1493 189 3375.0 459.0 3834 43640 26872.0 NaN
5375 2020-11-05T17:00:00 ITA 5 Veneto 45.434905 12.338452 1162 164 1326 39393 ... 3183 3264 25560 2516 25539.0 43256.0 68795 2397655 930576.0 NaN

5 rows × 21 columns

 

Variable names to English and their explanation

  • HospWithSymptoms : Currently hospitalized patients with symptoms
  • IC : Intensive care
  • HospTotal: Total number of currently hospitalized patients
  • AtHome : Currently at home confinement
  • CurrentlyPositive : Total amount of current positive cases (Hospitalised patients + Home confinement)
  • NewPositives : New amount of positive cases (Actual total amount of current positive cases - total amount of current positive cases of the previous day)
  • TotalCases : Total amount of positive cases
  • NoOfTests : Tests performed
Out[7]:
Date Region Lat Long HospWithSymptoms IC HospTotal AtHome CurrentlyPositive VariationOfPositives NewPositives Recovered Deaths Diagnostico Screening TotalCases NoOfTests casi_testati note Pop
Date
2020-11-01 2020-11-01 Veneto 45.434905 12.338452 832 132 964 30450 31414 2235 2300 25421 2418 25008.0 34245.0 59253 2342686 910040.0 NaN 4905854
2020-11-02 2020-11-02 Veneto 45.434905 12.338452 873 136 1009 31924 32933 1519 1544 25437 2427 25103.0 35694.0 60797 2350517 912972.0 NaN 4905854
2020-11-03 2020-11-03 Veneto 45.434905 12.338452 1011 142 1153 34013 35166 2233 2298 25471 2458 25215.0 37880.0 63095 2362039 917684.0 NaN 4905854
2020-11-04 2020-11-04 Veneto 45.434905 12.338452 1076 149 1225 36311 37536 2370 2436 25517 2478 25381.0 40150.0 65531 2381170 924415.0 NaN 4905854
2020-11-05 2020-11-05 Veneto 45.434905 12.338452 1162 164 1326 39393 40719 3183 3264 25560 2516 25539.0 43256.0 68795 2397655 930576.0 NaN 4905854

 

daily numbers & moving averages (MA)

(double click and click on legend to select one or multiple regions in the graph)

 

All regions together